home *** CD-ROM | disk | FTP | other *** search
/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 309 < prev    next >
Unknown  |  1998-01-30  |  646 b 
open in: MacOS 8.1     |     Win98     |     DOS

view JSON data     |     view as text


This file was not able to be converted.
This format is not currently supported by dexvert.

ConfidenceProgramDetectionMatch TypeSupport
100% file data default


hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 48 49 4c 44 20 49 4e | 53 45 52 54 20 53 45 54 |CHILD IN|SERT SET|
|00000010| 4e 55 4c 4c 00 20 20 2f | 2a 20 45 52 77 69 6e 20 |NULL.  /|* ERwin |
|00000020| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|00000030| 65 20 2a 2f 0d 0a 20 20 | 2f 2a 20 25 50 61 72 65 |e */..  |/* %Pare|
|00000040| 6e 74 20 25 56 65 72 62 | 50 68 72 61 73 65 20 25 |nt %Verb|Phrase %|
|00000050| 43 68 69 6c 64 20 4f 4e | 20 43 48 49 4c 44 20 49 |Child ON| CHILD I|
|00000060| 4e 53 45 52 54 20 53 45 | 54 20 4e 55 4c 4c 20 2a |NSERT SE|T NULL *|
|00000070| 2f 0d 0a 20 20 69 66 0d | 0a 20 20 20 20 2f 2a 20 |/..  if.|.    /* |
|00000080| 25 25 43 68 69 6c 64 46 | 4b 28 22 20 6f 72 22 2c |%%ChildF|K(" or",|
|00000090| 75 70 64 61 74 65 29 20 | 2a 2f 0d 0a 20 20 20 20 |update) |*/..    |
|000000a0| 25 43 68 69 6c 64 46 4b | 28 22 20 6f 72 22 2c 75 |%ChildFK|(" or",u|
|000000b0| 70 64 61 74 65 29 0d 0a | 20 20 62 65 67 69 6e 0d |pdate)..|  begin.|
|000000c0| 0a 20 20 20 20 75 70 64 | 61 74 65 20 25 43 68 69 |.    upd|ate %Chi|
|000000d0| 6c 64 0d 0a 20 20 20 20 | 20 20 73 65 74 0d 0a 20 |ld..    |  set.. |
|000000e0| 20 20 20 20 20 20 20 2f | 2a 20 25 25 53 65 74 46 |       /|* %%SetF|
|000000f0| 4b 28 25 43 68 69 6c 64 | 2c 4e 55 4c 4c 29 20 2a |K(%Child|,NULL) *|
|00000100| 2f 0d 0a 20 20 20 20 20 | 20 20 20 25 53 65 74 46 |/..     |   %SetF|
|00000110| 4b 28 25 43 68 69 6c 64 | 2c 4e 55 4c 4c 29 0d 0a |K(%Child|,NULL)..|
|00000120| 20 20 20 20 20 20 66 72 | 6f 6d 20 25 43 68 69 6c |      fr|om %Chil|
|00000130| 64 2c 69 6e 73 65 72 74 | 65 64 0d 0a 20 20 20 20 |d,insert|ed..    |
|00000140| 20 20 77 68 65 72 65 0d | 0a 20 20 20 20 20 20 20 |  where.|.       |
|00000150| 20 2f 2a 20 25 25 4a 6f | 69 6e 50 4b 50 4b 28 25 | /* %%Jo|inPKPK(%|
|00000160| 43 68 69 6c 64 2c 69 6e | 73 65 72 74 65 64 2c 22 |Child,in|serted,"|
|00000170| 20 3d 20 22 2c 22 20 61 | 6e 64 22 29 20 2a 2f 0d | = "," a|nd") */.|
|00000180| 0a 20 20 20 20 20 20 20 | 20 25 4a 6f 69 6e 50 4b |.       | %JoinPK|
|00000190| 50 4b 28 25 43 68 69 6c | 64 2c 69 6e 73 65 72 74 |PK(%Chil|d,insert|
|000001a0| 65 64 2c 22 20 3d 20 22 | 2c 22 20 61 6e 64 22 29 |ed," = "|," and")|
|000001b0| 20 61 6e 64 0d 0a 20 20 | 20 20 20 20 20 20 6e 6f | and..  |      no|
|000001c0| 74 20 65 78 69 73 74 73 | 20 28 0d 0a 20 20 20 20 |t exists| (..    |
|000001d0| 20 20 20 20 20 20 73 65 | 6c 65 63 74 20 2a 20 66 |      se|lect * f|
|000001e0| 72 6f 6d 20 25 50 61 72 | 65 6e 74 0d 0a 20 20 20 |rom %Par|ent..   |
|000001f0| 20 20 20 20 20 20 20 77 | 68 65 72 65 0d 0a 20 20 |       w|here..  |
|00000200| 20 20 20 20 20 20 20 20 | 20 20 2f 2a 20 25 25 4a |        |  /* %%J|
|00000210| 6f 69 6e 46 4b 50 4b 28 | 69 6e 73 65 72 74 65 64 |oinFKPK(|inserted|
|00000220| 2c 25 50 61 72 65 6e 74 | 2c 22 20 3d 20 22 2c 22 |,%Parent|," = ","|
|00000230| 20 61 6e 64 22 29 20 2a | 2f 0d 0a 20 20 20 20 20 | and") *|/..     |
|00000240| 20 20 20 20 20 20 20 25 | 4a 6f 69 6e 46 4b 50 4b |       %|JoinFKPK|
|00000250| 28 69 6e 73 65 72 74 65 | 64 2c 25 50 61 72 65 6e |(inserte|d,%Paren|
|00000260| 74 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 0d |t," = ",|" and").|
|00000270| 0a 20 20 20 20 20 20 20 | 20 29 0d 0a 20 20 65 6e |.       | )..  en|
|00000280| 64 0d 0a 00 1a 27       |                         |d....'  |        |
+--------+-------------------------+-------------------------+--------+--------+